package com.hzqy.persistence.dao.statistics;

import java.util.List;
import java.util.Map;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Repository;

import com.hzqy.persistence.dao.core.PersistenceDao;
import com.hzqy.web.vo.PmsUserVo;
import com.hzqy.web.vo.StatDataSubscriptionAreaVo;
import com.hzqy.web.vo.StatDataSubscriptionVo;
import com.hzqy.web.vo.SysAreaVo;

@Repository
public class SubscriptionDao extends PersistenceDao<PmsUserVo, Integer>{
	protected final Logger LOG = LoggerFactory.getLogger(SubscriptionDao.class);
	
	public List<SysAreaVo> selectAreaTree(SysAreaVo sav){
		String namespace = this.getNamespace();
		return getSqlSession().selectList(namespace + "selectAreaTree",sav);
	}
	
	public int selectSubscriptionCount(StatDataSubscriptionVo statDataSubscriptionVo) {
		String namespace = this.getNamespace();
		return getSqlSession().selectOne(namespace + "selectSubscriptionCount", statDataSubscriptionVo);
	}
	
	public List<StatDataSubscriptionVo> selectSubscriptionList(Map<String,Object> map){
		String namespace = this.getNamespace();
		return getSqlSession().selectList(namespace + "selectSubscriptionList", map);
	}
	
	public List<StatDataSubscriptionVo> selectSubscriptionExcelList(Map<String,Object> map){
		String namespace = this.getNamespace();
		return getSqlSession().selectList(namespace + "selectSubscriptionExcelList", map);
	}
	
	public int selectSubscriptionAreaCount(StatDataSubscriptionAreaVo statDataSubscriptionAreaVo) {
		String namespace = this.getNamespace();
		return getSqlSession().selectOne(namespace + "selectSubscriptionAreaCount", statDataSubscriptionAreaVo);
	}
	
	public List<StatDataSubscriptionAreaVo> selectSubscriptionAreaList(Map<String,Object> map){
		String namespace = this.getNamespace();
		return getSqlSession().selectList(namespace + "selectSubscriptionAreaList", map);
	}
	
	public List<StatDataSubscriptionAreaVo> selectSubscriptionAreaExcelList(Map<String,Object> map){
		String namespace = this.getNamespace();
		return getSqlSession().selectList(namespace + "selectSubscriptionAreaExcelList", map);
	}
}
